package com.zhangwei.day38.dao;

/**
 * @author zhangwei
 * @version V1.0
 * @Title: Advanced
 * @Package com.zhangwei.day38.dao
 * @Description:
 * @date 15/10/20 下午3:02
 */

public class DbBean {

    public static class UserDb {
        public static final String TAB_NAME = "user";
        public static final String id = "ID";
        public static final String name = "NAME";
        public static final String pwd = "PWD";
        public static final String CRATE_TAB =
                "CREATE TABLE IF NOT EXISTS " + TAB_NAME
                        + " ( "
                        + id + " INTEGER PRIMARY KEY AUTOINCREMENT,"
                        + name + " text,"
                        + pwd + " text"
                        + ")";
        public static final String DROP_TAB = "DROP TABLE " + TAB_NAME;
    }


    public static class GoodDb {
        public static final String TAB_NAME = "GOOD";
        public static final String name = "NAME";
        public static final String id = "ID";

        public static final String CRATE_TAB =
                "CREATE TABLE IF NOT EXISTS " + TAB_NAME
                        + " ( "
                        + id + " INTEGER PRIMARY KEY AUTOINCREMENT,"
                        + name + " text,"
                        + ")";
        public static final String DROP_TAB = "DROP TABLE " + TAB_NAME;

    }

}
